package com.nmf.dao.gen;

import com.nmf.dao.gen.bean.BizApplyBill;
import com.nmf.dao.gen.bean.BizApplyBillExample;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.DeleteProvider;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.InsertProvider;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.apache.ibatis.annotations.Update;
import org.apache.ibatis.annotations.UpdateProvider;
import org.apache.ibatis.type.JdbcType;

public interface BizApplyBillMapper {
    /** biz_apply_bill */
    @SelectProvider(type=BizApplyBillSqlProvider.class, method="countByExample")
    long countByExample(BizApplyBillExample example);

    /** biz_apply_bill */
    @DeleteProvider(type=BizApplyBillSqlProvider.class, method="deleteByExample")
    int deleteByExample(BizApplyBillExample example);

    /** biz_apply_bill */
    @Delete({
        "delete from biz_apply_bill",
        "where id = #{id,jdbcType=VARCHAR}"
    })
    int deleteByPrimaryKey(String id);

    /** biz_apply_bill */
    @Insert({
        "insert into biz_apply_bill (id, bill_status, ",
        "apply_type, category_id, ",
        "category_name, apply_book_id, ",
        "zhuying_shouru, zhuying_shouru_zj, ",
        "zhuying_shouru_zhuanjia, jinfei_zhichu, ",
        "jinfei_zhichu_zj, jinfei_zhichu_zhuanjia, ",
        "shiyan_renyuan, zhigong_num, ",
        "zhuanjia_shu, boshi_shu, ",
        "waibuzhuanjia_shu, yanfa_xiangmu_num, ",
        "yanjiu_num, guojia_yanfa_num, ",
        "sheng_yanfa_num, jigou_num, ",
        "shbei_price, shbei_price_zj, ",
        "shbei_zhuanjia, zhuanli_num, ",
        "year_zhuanli_num, shengqing_zhuanli, ",
        "biaozhun_shu, new_good_sell, ",
        "new_good_sell_zj, new_gsell_zhuanjia, ",
        "new_sell_prohibt, new_sell_prohibt_zj, ",
        "new_sell_prohibt_zhuanjia, all_prohibt, ",
        "all_prohibt_zj, all_prohibt_zhuanjia, ",
        "jiangxiang_shu, comp_name, ",
        "address, zhuying_yewu, ",
        "comp_faren, zhongxin_person, ",
        "link_man, mail, comp_url, ",
        "xiashu_shu, xiashu_daima, ",
        "province_audit_id, province_audit_name, ",
        "country_audit_id, country_audit_name, ",
        "province_id, province_name, ",
        "opt_id, opt_name, ",
        "create_date, update_date)",
        "values (#{id,jdbcType=VARCHAR}, #{billStatus,jdbcType=SMALLINT}, ",
        "#{applyType,jdbcType=SMALLINT}, #{categoryId,jdbcType=VARCHAR}, ",
        "#{categoryName,jdbcType=VARCHAR}, #{applyBookId,jdbcType=VARCHAR}, ",
        "#{zhuyingShouru,jdbcType=DOUBLE}, #{zhuyingShouruZj,jdbcType=DOUBLE}, ",
        "#{zhuyingShouruZhuanjia,jdbcType=VARCHAR}, #{jinfeiZhichu,jdbcType=DOUBLE}, ",
        "#{jinfeiZhichuZj,jdbcType=DOUBLE}, #{jinfeiZhichuZhuanjia,jdbcType=VARCHAR}, ",
        "#{shiyanRenyuan,jdbcType=INTEGER}, #{zhigongNum,jdbcType=INTEGER}, ",
        "#{zhuanjiaShu,jdbcType=INTEGER}, #{boshiShu,jdbcType=INTEGER}, ",
        "#{waibuzhuanjiaShu,jdbcType=INTEGER}, #{yanfaXiangmuNum,jdbcType=INTEGER}, ",
        "#{yanjiuNum,jdbcType=INTEGER}, #{guojiaYanfaNum,jdbcType=INTEGER}, ",
        "#{shengYanfaNum,jdbcType=INTEGER}, #{jigouNum,jdbcType=INTEGER}, ",
        "#{shbeiPrice,jdbcType=DOUBLE}, #{shbeiPriceZj,jdbcType=DOUBLE}, ",
        "#{shbeiZhuanjia,jdbcType=VARCHAR}, #{zhuanliNum,jdbcType=INTEGER}, ",
        "#{yearZhuanliNum,jdbcType=INTEGER}, #{shengqingZhuanli,jdbcType=INTEGER}, ",
        "#{biaozhunShu,jdbcType=INTEGER}, #{newGoodSell,jdbcType=DOUBLE}, ",
        "#{newGoodSellZj,jdbcType=DOUBLE}, #{newGsellZhuanjia,jdbcType=VARCHAR}, ",
        "#{newSellProhibt,jdbcType=DOUBLE}, #{newSellProhibtZj,jdbcType=DOUBLE}, ",
        "#{newSellProhibtZhuanjia,jdbcType=VARCHAR}, #{allProhibt,jdbcType=DOUBLE}, ",
        "#{allProhibtZj,jdbcType=DOUBLE}, #{allProhibtZhuanjia,jdbcType=VARCHAR}, ",
        "#{jiangxiangShu,jdbcType=INTEGER}, #{compName,jdbcType=VARCHAR}, ",
        "#{address,jdbcType=VARCHAR}, #{zhuyingYewu,jdbcType=VARCHAR}, ",
        "#{compFaren,jdbcType=VARCHAR}, #{zhongxinPerson,jdbcType=VARCHAR}, ",
        "#{linkMan,jdbcType=VARCHAR}, #{mail,jdbcType=VARCHAR}, #{compUrl,jdbcType=VARCHAR}, ",
        "#{xiashuShu,jdbcType=INTEGER}, #{xiashuDaima,jdbcType=VARCHAR}, ",
        "#{provinceAuditId,jdbcType=VARCHAR}, #{provinceAuditName,jdbcType=VARCHAR}, ",
        "#{countryAuditId,jdbcType=VARCHAR}, #{countryAuditName,jdbcType=VARCHAR}, ",
        "#{provinceId,jdbcType=VARCHAR}, #{provinceName,jdbcType=VARCHAR}, ",
        "#{optId,jdbcType=VARCHAR}, #{optName,jdbcType=VARCHAR}, ",
        "#{createDate,jdbcType=TIMESTAMP}, #{updateDate,jdbcType=TIMESTAMP})"
    })
    int insert(BizApplyBill record);

    /** biz_apply_bill */
    @InsertProvider(type=BizApplyBillSqlProvider.class, method="insertSelective")
    int insertSelective(BizApplyBill record);

    /** biz_apply_bill */
    @SelectProvider(type=BizApplyBillSqlProvider.class, method="selectByExample")
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.VARCHAR, id=true),
        @Result(column="bill_status", property="billStatus", jdbcType=JdbcType.SMALLINT),
        @Result(column="apply_type", property="applyType", jdbcType=JdbcType.SMALLINT),
        @Result(column="category_id", property="categoryId", jdbcType=JdbcType.VARCHAR),
        @Result(column="category_name", property="categoryName", jdbcType=JdbcType.VARCHAR),
        @Result(column="apply_book_id", property="applyBookId", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhuying_shouru", property="zhuyingShouru", jdbcType=JdbcType.DOUBLE),
        @Result(column="zhuying_shouru_zj", property="zhuyingShouruZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="zhuying_shouru_zhuanjia", property="zhuyingShouruZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="jinfei_zhichu", property="jinfeiZhichu", jdbcType=JdbcType.DOUBLE),
        @Result(column="jinfei_zhichu_zj", property="jinfeiZhichuZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="jinfei_zhichu_zhuanjia", property="jinfeiZhichuZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="shiyan_renyuan", property="shiyanRenyuan", jdbcType=JdbcType.INTEGER),
        @Result(column="zhigong_num", property="zhigongNum", jdbcType=JdbcType.INTEGER),
        @Result(column="zhuanjia_shu", property="zhuanjiaShu", jdbcType=JdbcType.INTEGER),
        @Result(column="boshi_shu", property="boshiShu", jdbcType=JdbcType.INTEGER),
        @Result(column="waibuzhuanjia_shu", property="waibuzhuanjiaShu", jdbcType=JdbcType.INTEGER),
        @Result(column="yanfa_xiangmu_num", property="yanfaXiangmuNum", jdbcType=JdbcType.INTEGER),
        @Result(column="yanjiu_num", property="yanjiuNum", jdbcType=JdbcType.INTEGER),
        @Result(column="guojia_yanfa_num", property="guojiaYanfaNum", jdbcType=JdbcType.INTEGER),
        @Result(column="sheng_yanfa_num", property="shengYanfaNum", jdbcType=JdbcType.INTEGER),
        @Result(column="jigou_num", property="jigouNum", jdbcType=JdbcType.INTEGER),
        @Result(column="shbei_price", property="shbeiPrice", jdbcType=JdbcType.DOUBLE),
        @Result(column="shbei_price_zj", property="shbeiPriceZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="shbei_zhuanjia", property="shbeiZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhuanli_num", property="zhuanliNum", jdbcType=JdbcType.INTEGER),
        @Result(column="year_zhuanli_num", property="yearZhuanliNum", jdbcType=JdbcType.INTEGER),
        @Result(column="shengqing_zhuanli", property="shengqingZhuanli", jdbcType=JdbcType.INTEGER),
        @Result(column="biaozhun_shu", property="biaozhunShu", jdbcType=JdbcType.INTEGER),
        @Result(column="new_good_sell", property="newGoodSell", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_good_sell_zj", property="newGoodSellZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_gsell_zhuanjia", property="newGsellZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="new_sell_prohibt", property="newSellProhibt", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_sell_prohibt_zj", property="newSellProhibtZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_sell_prohibt_zhuanjia", property="newSellProhibtZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="all_prohibt", property="allProhibt", jdbcType=JdbcType.DOUBLE),
        @Result(column="all_prohibt_zj", property="allProhibtZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="all_prohibt_zhuanjia", property="allProhibtZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="jiangxiang_shu", property="jiangxiangShu", jdbcType=JdbcType.INTEGER),
        @Result(column="comp_name", property="compName", jdbcType=JdbcType.VARCHAR),
        @Result(column="address", property="address", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhuying_yewu", property="zhuyingYewu", jdbcType=JdbcType.VARCHAR),
        @Result(column="comp_faren", property="compFaren", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhongxin_person", property="zhongxinPerson", jdbcType=JdbcType.VARCHAR),
        @Result(column="link_man", property="linkMan", jdbcType=JdbcType.VARCHAR),
        @Result(column="mail", property="mail", jdbcType=JdbcType.VARCHAR),
        @Result(column="comp_url", property="compUrl", jdbcType=JdbcType.VARCHAR),
        @Result(column="xiashu_shu", property="xiashuShu", jdbcType=JdbcType.INTEGER),
        @Result(column="xiashu_daima", property="xiashuDaima", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_audit_id", property="provinceAuditId", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_audit_name", property="provinceAuditName", jdbcType=JdbcType.VARCHAR),
        @Result(column="country_audit_id", property="countryAuditId", jdbcType=JdbcType.VARCHAR),
        @Result(column="country_audit_name", property="countryAuditName", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_id", property="provinceId", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_name", property="provinceName", jdbcType=JdbcType.VARCHAR),
        @Result(column="opt_id", property="optId", jdbcType=JdbcType.VARCHAR),
        @Result(column="opt_name", property="optName", jdbcType=JdbcType.VARCHAR),
        @Result(column="create_date", property="createDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="update_date", property="updateDate", jdbcType=JdbcType.TIMESTAMP)
    })
    List<BizApplyBill> selectByExample(BizApplyBillExample example);

    /** biz_apply_bill */
    @Select({
        "select",
        "id, bill_status, apply_type, category_id, category_name, apply_book_id, zhuying_shouru, ",
        "zhuying_shouru_zj, zhuying_shouru_zhuanjia, jinfei_zhichu, jinfei_zhichu_zj, ",
        "jinfei_zhichu_zhuanjia, shiyan_renyuan, zhigong_num, zhuanjia_shu, boshi_shu, ",
        "waibuzhuanjia_shu, yanfa_xiangmu_num, yanjiu_num, guojia_yanfa_num, sheng_yanfa_num, ",
        "jigou_num, shbei_price, shbei_price_zj, shbei_zhuanjia, zhuanli_num, year_zhuanli_num, ",
        "shengqing_zhuanli, biaozhun_shu, new_good_sell, new_good_sell_zj, new_gsell_zhuanjia, ",
        "new_sell_prohibt, new_sell_prohibt_zj, new_sell_prohibt_zhuanjia, all_prohibt, ",
        "all_prohibt_zj, all_prohibt_zhuanjia, jiangxiang_shu, comp_name, address, zhuying_yewu, ",
        "comp_faren, zhongxin_person, link_man, mail, comp_url, xiashu_shu, xiashu_daima, ",
        "province_audit_id, province_audit_name, country_audit_id, country_audit_name, ",
        "province_id, province_name, opt_id, opt_name, create_date, update_date",
        "from biz_apply_bill",
        "where id = #{id,jdbcType=VARCHAR}"
    })
    @Results({
        @Result(column="id", property="id", jdbcType=JdbcType.VARCHAR, id=true),
        @Result(column="bill_status", property="billStatus", jdbcType=JdbcType.SMALLINT),
        @Result(column="apply_type", property="applyType", jdbcType=JdbcType.SMALLINT),
        @Result(column="category_id", property="categoryId", jdbcType=JdbcType.VARCHAR),
        @Result(column="category_name", property="categoryName", jdbcType=JdbcType.VARCHAR),
        @Result(column="apply_book_id", property="applyBookId", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhuying_shouru", property="zhuyingShouru", jdbcType=JdbcType.DOUBLE),
        @Result(column="zhuying_shouru_zj", property="zhuyingShouruZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="zhuying_shouru_zhuanjia", property="zhuyingShouruZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="jinfei_zhichu", property="jinfeiZhichu", jdbcType=JdbcType.DOUBLE),
        @Result(column="jinfei_zhichu_zj", property="jinfeiZhichuZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="jinfei_zhichu_zhuanjia", property="jinfeiZhichuZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="shiyan_renyuan", property="shiyanRenyuan", jdbcType=JdbcType.INTEGER),
        @Result(column="zhigong_num", property="zhigongNum", jdbcType=JdbcType.INTEGER),
        @Result(column="zhuanjia_shu", property="zhuanjiaShu", jdbcType=JdbcType.INTEGER),
        @Result(column="boshi_shu", property="boshiShu", jdbcType=JdbcType.INTEGER),
        @Result(column="waibuzhuanjia_shu", property="waibuzhuanjiaShu", jdbcType=JdbcType.INTEGER),
        @Result(column="yanfa_xiangmu_num", property="yanfaXiangmuNum", jdbcType=JdbcType.INTEGER),
        @Result(column="yanjiu_num", property="yanjiuNum", jdbcType=JdbcType.INTEGER),
        @Result(column="guojia_yanfa_num", property="guojiaYanfaNum", jdbcType=JdbcType.INTEGER),
        @Result(column="sheng_yanfa_num", property="shengYanfaNum", jdbcType=JdbcType.INTEGER),
        @Result(column="jigou_num", property="jigouNum", jdbcType=JdbcType.INTEGER),
        @Result(column="shbei_price", property="shbeiPrice", jdbcType=JdbcType.DOUBLE),
        @Result(column="shbei_price_zj", property="shbeiPriceZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="shbei_zhuanjia", property="shbeiZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhuanli_num", property="zhuanliNum", jdbcType=JdbcType.INTEGER),
        @Result(column="year_zhuanli_num", property="yearZhuanliNum", jdbcType=JdbcType.INTEGER),
        @Result(column="shengqing_zhuanli", property="shengqingZhuanli", jdbcType=JdbcType.INTEGER),
        @Result(column="biaozhun_shu", property="biaozhunShu", jdbcType=JdbcType.INTEGER),
        @Result(column="new_good_sell", property="newGoodSell", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_good_sell_zj", property="newGoodSellZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_gsell_zhuanjia", property="newGsellZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="new_sell_prohibt", property="newSellProhibt", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_sell_prohibt_zj", property="newSellProhibtZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="new_sell_prohibt_zhuanjia", property="newSellProhibtZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="all_prohibt", property="allProhibt", jdbcType=JdbcType.DOUBLE),
        @Result(column="all_prohibt_zj", property="allProhibtZj", jdbcType=JdbcType.DOUBLE),
        @Result(column="all_prohibt_zhuanjia", property="allProhibtZhuanjia", jdbcType=JdbcType.VARCHAR),
        @Result(column="jiangxiang_shu", property="jiangxiangShu", jdbcType=JdbcType.INTEGER),
        @Result(column="comp_name", property="compName", jdbcType=JdbcType.VARCHAR),
        @Result(column="address", property="address", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhuying_yewu", property="zhuyingYewu", jdbcType=JdbcType.VARCHAR),
        @Result(column="comp_faren", property="compFaren", jdbcType=JdbcType.VARCHAR),
        @Result(column="zhongxin_person", property="zhongxinPerson", jdbcType=JdbcType.VARCHAR),
        @Result(column="link_man", property="linkMan", jdbcType=JdbcType.VARCHAR),
        @Result(column="mail", property="mail", jdbcType=JdbcType.VARCHAR),
        @Result(column="comp_url", property="compUrl", jdbcType=JdbcType.VARCHAR),
        @Result(column="xiashu_shu", property="xiashuShu", jdbcType=JdbcType.INTEGER),
        @Result(column="xiashu_daima", property="xiashuDaima", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_audit_id", property="provinceAuditId", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_audit_name", property="provinceAuditName", jdbcType=JdbcType.VARCHAR),
        @Result(column="country_audit_id", property="countryAuditId", jdbcType=JdbcType.VARCHAR),
        @Result(column="country_audit_name", property="countryAuditName", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_id", property="provinceId", jdbcType=JdbcType.VARCHAR),
        @Result(column="province_name", property="provinceName", jdbcType=JdbcType.VARCHAR),
        @Result(column="opt_id", property="optId", jdbcType=JdbcType.VARCHAR),
        @Result(column="opt_name", property="optName", jdbcType=JdbcType.VARCHAR),
        @Result(column="create_date", property="createDate", jdbcType=JdbcType.TIMESTAMP),
        @Result(column="update_date", property="updateDate", jdbcType=JdbcType.TIMESTAMP)
    })
    BizApplyBill selectByPrimaryKey(String id);

    /** biz_apply_bill */
    @UpdateProvider(type=BizApplyBillSqlProvider.class, method="updateByExampleSelective")
    int updateByExampleSelective(@Param("record") BizApplyBill record, @Param("example") BizApplyBillExample example);

    /** biz_apply_bill */
    @UpdateProvider(type=BizApplyBillSqlProvider.class, method="updateByExample")
    int updateByExample(@Param("record") BizApplyBill record, @Param("example") BizApplyBillExample example);

    /** biz_apply_bill */
    @UpdateProvider(type=BizApplyBillSqlProvider.class, method="updateByPrimaryKeySelective")
    int updateByPrimaryKeySelective(BizApplyBill record);

    /** biz_apply_bill */
    @Update({
        "update biz_apply_bill",
        "set bill_status = #{billStatus,jdbcType=SMALLINT},",
          "apply_type = #{applyType,jdbcType=SMALLINT},",
          "category_id = #{categoryId,jdbcType=VARCHAR},",
          "category_name = #{categoryName,jdbcType=VARCHAR},",
          "apply_book_id = #{applyBookId,jdbcType=VARCHAR},",
          "zhuying_shouru = #{zhuyingShouru,jdbcType=DOUBLE},",
          "zhuying_shouru_zj = #{zhuyingShouruZj,jdbcType=DOUBLE},",
          "zhuying_shouru_zhuanjia = #{zhuyingShouruZhuanjia,jdbcType=VARCHAR},",
          "jinfei_zhichu = #{jinfeiZhichu,jdbcType=DOUBLE},",
          "jinfei_zhichu_zj = #{jinfeiZhichuZj,jdbcType=DOUBLE},",
          "jinfei_zhichu_zhuanjia = #{jinfeiZhichuZhuanjia,jdbcType=VARCHAR},",
          "shiyan_renyuan = #{shiyanRenyuan,jdbcType=INTEGER},",
          "zhigong_num = #{zhigongNum,jdbcType=INTEGER},",
          "zhuanjia_shu = #{zhuanjiaShu,jdbcType=INTEGER},",
          "boshi_shu = #{boshiShu,jdbcType=INTEGER},",
          "waibuzhuanjia_shu = #{waibuzhuanjiaShu,jdbcType=INTEGER},",
          "yanfa_xiangmu_num = #{yanfaXiangmuNum,jdbcType=INTEGER},",
          "yanjiu_num = #{yanjiuNum,jdbcType=INTEGER},",
          "guojia_yanfa_num = #{guojiaYanfaNum,jdbcType=INTEGER},",
          "sheng_yanfa_num = #{shengYanfaNum,jdbcType=INTEGER},",
          "jigou_num = #{jigouNum,jdbcType=INTEGER},",
          "shbei_price = #{shbeiPrice,jdbcType=DOUBLE},",
          "shbei_price_zj = #{shbeiPriceZj,jdbcType=DOUBLE},",
          "shbei_zhuanjia = #{shbeiZhuanjia,jdbcType=VARCHAR},",
          "zhuanli_num = #{zhuanliNum,jdbcType=INTEGER},",
          "year_zhuanli_num = #{yearZhuanliNum,jdbcType=INTEGER},",
          "shengqing_zhuanli = #{shengqingZhuanli,jdbcType=INTEGER},",
          "biaozhun_shu = #{biaozhunShu,jdbcType=INTEGER},",
          "new_good_sell = #{newGoodSell,jdbcType=DOUBLE},",
          "new_good_sell_zj = #{newGoodSellZj,jdbcType=DOUBLE},",
          "new_gsell_zhuanjia = #{newGsellZhuanjia,jdbcType=VARCHAR},",
          "new_sell_prohibt = #{newSellProhibt,jdbcType=DOUBLE},",
          "new_sell_prohibt_zj = #{newSellProhibtZj,jdbcType=DOUBLE},",
          "new_sell_prohibt_zhuanjia = #{newSellProhibtZhuanjia,jdbcType=VARCHAR},",
          "all_prohibt = #{allProhibt,jdbcType=DOUBLE},",
          "all_prohibt_zj = #{allProhibtZj,jdbcType=DOUBLE},",
          "all_prohibt_zhuanjia = #{allProhibtZhuanjia,jdbcType=VARCHAR},",
          "jiangxiang_shu = #{jiangxiangShu,jdbcType=INTEGER},",
          "comp_name = #{compName,jdbcType=VARCHAR},",
          "address = #{address,jdbcType=VARCHAR},",
          "zhuying_yewu = #{zhuyingYewu,jdbcType=VARCHAR},",
          "comp_faren = #{compFaren,jdbcType=VARCHAR},",
          "zhongxin_person = #{zhongxinPerson,jdbcType=VARCHAR},",
          "link_man = #{linkMan,jdbcType=VARCHAR},",
          "mail = #{mail,jdbcType=VARCHAR},",
          "comp_url = #{compUrl,jdbcType=VARCHAR},",
          "xiashu_shu = #{xiashuShu,jdbcType=INTEGER},",
          "xiashu_daima = #{xiashuDaima,jdbcType=VARCHAR},",
          "province_audit_id = #{provinceAuditId,jdbcType=VARCHAR},",
          "province_audit_name = #{provinceAuditName,jdbcType=VARCHAR},",
          "country_audit_id = #{countryAuditId,jdbcType=VARCHAR},",
          "country_audit_name = #{countryAuditName,jdbcType=VARCHAR},",
          "province_id = #{provinceId,jdbcType=VARCHAR},",
          "province_name = #{provinceName,jdbcType=VARCHAR},",
          "opt_id = #{optId,jdbcType=VARCHAR},",
          "opt_name = #{optName,jdbcType=VARCHAR},",
          "create_date = #{createDate,jdbcType=TIMESTAMP},",
          "update_date = #{updateDate,jdbcType=TIMESTAMP}",
        "where id = #{id,jdbcType=VARCHAR}"
    })
    int updateByPrimaryKey(BizApplyBill record);
}